﻿INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (1,'Bill Charges')  
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (2,'Bill Category')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (3,'Patient Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (4,'Payment Mode')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (5,'Item Category')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (6,'UOM')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (7,'Employee Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (8,'Marital Status')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (9,'Relationship')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (10,'Specialization')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (11,'Doctor Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (12,'Recall Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (13,'Recall Status')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (14,'Procedure Category')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (15,'Room Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (16,'Appointment Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (17,'Appointment Status')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (18,'Contact Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (19,'Visit Status')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (20,'Habits')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (21,'Immunization')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (22,'Health Status')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (23,'Language')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (24,'Confidential')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (25,'Religion')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (26,'BloodGroup')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (27,'Diet')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (28,'Investigation Category')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (29,'Problem Timing')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (30,'Problem Duration')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (31,'Problem Location')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (32,'Severity')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (33,'Problem Category')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (34,'Finding Category')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (35,'Medicine Type')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (36,'Medicine Manufacturer')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (37,'Generic Drug')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (38,'Medicine Frequency')    
GO
INSERT INTO [HMSIndia].[dbo].[LookupTypes] ([LookupTypeID],[LookupType]) VALUES (39,'Periods')    
GO


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

INSERT INTO [HMSIndia].[dbo].[LookupsMaster](ID, [Name] ,[Type] ,[Rate] ,[SystemDefined] ,[Remarks]) VALUES(3,'Out-Patient Department',3,NULL,1, NULL)
GO

INSERT INTO [HMSIndia].[dbo].[LookupsMaster](ID, [Name] ,[Type] ,[Rate] ,[SystemDefined] ,[Remarks]) VALUES(4,'In-Patient Department',3,NULL,1, NULL)
GO

INSERT INTO [HMSIndia].[dbo].[LookupsMaster](ID, [Name] ,[Type] ,[Rate] ,[SystemDefined] ,[Remarks]) VALUES(26,'Consultation',15,NULL,1, NULL)
GO

INSERT INTO [HMSIndia].[dbo].[LookupsMaster](ID, [Name] ,[Type] ,[Rate] ,[SystemDefined] ,[Remarks]) VALUES(27,'General',15,NULL,1, NULL)
GO

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


--Admin User Login

INSERT INTO [HMSIndia].[dbo].[SecurityMaster]
           ([UserName]
           ,[Password]
           ,[CreatedBy]
           ,[CreatedDatetime]
           ,[IsSuperUser]
           ,[IsLocked])
     VALUES
           ('Admin'
           ,'870-900-990-950-1000'
           ,1
           ,GETDATE()
           ,1
           ,0)
GO

--UserName and Password = "admin"